Problems inserting chinese characters

All, I have an application in which I am trying to insert some traditional Chinese characters. The insert statement probably won't cut and paste correctly but it is: insert into TKTS13 values (2,'ÄãºÃ', 'ÄãºÃ'); I have used this website http://people.w3.org/rishida/scripts/uniview/conversion

UNSIGNED_FLAG returned for column type timestamp ?

I'm using the MySQL 5.0.15 client to a 5.0 server all 32-bit windows. It appears that the UNSIGNED_FLAG is being returned for column types of timestamp. Checking the flags variable of the MYSQL_FIELD structure indicates that the following flags are returned: Field-flags = 1249 NOT_NULL_FLAG

Information schema for pages ?

All, I've searched the help and even found this very useful link http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html regarding all the Information schemas. What I can find is information regarding some way to retrieve the number of pages used to store an index. Perhaps this is because

Constraint checking

When does constraint checking occur? I can create a table that has a constraint on a column that doesn't exist. I would expect an error on the table creation, but the table gets created successfully. I'm running on windows 5.0.18 client/server. mysql show create table product;

RE: Relocation error during link

and the problem persists. I didn't have this problem with the 4.1.7 client, it only occurs with the 5.0 client and only on Solaris 64bit. Any help would be greatly appreciated. Thanks. Barbara -Original Message- From: Barbara Deaton [mailto:[EMAIL PROTECTED] Sent: Monday, January 30

Relocation error during link

client applications on Solaris? The pages I did find didn't mention this error. Thanks for your time and information. Barbara Deaton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cursor support

All, I'm actually looking for a RTFM reply here. I need to simulate SQLSetPos and SQLBulkOperations in my application which is written with the MySQL C API. I thought MySQL 5.0 was supposed to have cursor support, but the only thing I can find in the documentation is regarding server side

RE: Re: Problem with load data and NULL

@lists.mysql.com Subject: Re: Problem with load data and NULL In article [EMAIL PROTECTED], Barbara Deaton [EMAIL PROTECTED] writes: All, I need help with using load data to load a text file that is created by another application. I have a text file that contains 2 columns, date and smallint and 2 rows

Problem with load data and NULL

All, I need help with using load data to load a text file that is created by another application. I have a text file that contains 2 columns, date and smallint and 2 rows: d,e 2005-12-31, ,2 In the above example the first row, column e should be NULL and the second row column d should be

RE: SOCKET directory

try to connect I get the error: Have a look here: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html Barbara Deaton wrote: With MySQL 4.0 when I wanted to run my application on any of the unix = boxes I had to set the MYSQL_UNIX_PORT environment variable to point

RE: SOCKET directory

To: Barbara Deaton Cc: Gleb Paharenko; mysql@lists.mysql.com Subject: RE: SOCKET directory The sock file is not a permanent file. It is a socket descriptor that should only exist if the MySQL server is running and if the server is configured to supports socket-type connections. Most of the default

SOCKET directory

With MySQL 4.0 when I wanted to run my application on any of the unix boxes I had to set the MYSQL_UNIX_PORT environment variable to point to the location of my socket file. Looking through my 4.1.9 install I no longer see a mysql/socket directory. However, when I try to connect I get the

5.0 backward application supp

I currently have an application that is written on the 4.0 C API, but supports both 4.1 and 4.0 client/server. My question is if I move my application to support 5.0 and some of the new API's will the 5.0 Application/client be able to communicate with a 4.1 or 4.0 server? I support windows,

Where exists query syntax error?

I need help re-writing a query. When accessing DB2 I can execute the below: delete from DM_KOHLS.clr_plan_price_change_metrics A where A.start_dt= Date( '05/15/2005' ) and

RE: Where exists query syntax error?

I apologize for not providing more information. I am currently using 4.1.8 client and server on windows xp. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 11:48 AM To: Barbara Deaton Cc: mysql@lists.mysql.com Subject: Re

Date arithmetic: 2005-08-31 - 1

All, I know MySQL comes with all sorts of wonderful functions to do date arithmetic, the problem is the context that my application is being called in I don't know if a user wants me to add or subtract days. I'm just given the number of days that need to be either added or subtracted from the

RE: Date arithmetic: 2005-08-31 - 1

To: Barbara Deaton; mysql@lists.mysql.com Subject: AW: Date arithmetic: 2005-08-31 - 1 Barbara, Can't you use the ADDDATE function ? http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html Freddie -Ursprüngliche Nachricht- Von: Barbara Deaton [mailto:[EMAIL PROTECTED] Gesendet