Egor
As you said I have set the
default-character-set = sjis
But I need few clarfications for my strange problems
I am using mysql 4.0.3-beta(innodb) on windows NT 4.0 (SP6) machine
1. Under \MYSQL_HOME\SHARE\CHARSETS, there is no config file for sjis like
the ones for cp1251, german1 etc. Will this affect the charset structure for
japanese
2. Secondly I
created a table
CREATE TABLE PLOT_DB( plotname VARCHAR(5) NOT NULL PRIMARY KEY ) TYPE =
INNODB ;
When I insert japanese alphabets of size 1 from a text file, it throws
error--> primary key violation. ( the characters I am inserting are unique)
When I removed PRIMARY KEY constraint, they are inserted without any error
3. But When I use select * from plot_db, the characters are not properly
displayed and are masked. But when the size is reduced to 1 ( VARCHAR(1) ),
they are displayed properly
In DB tools the characters are displayed followed by a dot mark. when the
size is VARCHAR(5). They are displayed properly when the VARCHAR(1), that is
the exact size of the characters.
4. When I load the characters back to a text file, the same distortion is
found.
How can I rectify these errors ?
My problem is this happens exactly when the varchar size, I am declaring
exceeds the actual size of the characters I am inserting. That too only for
certain characters.
5. How MySQL handles the data transfer? Is it binary mode or ASCII mode?
regards
----- Original Message -----
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 7:51 PM
Subject: re: language charset
> kayamboo,
> Tuesday, October 15, 2002, 12:31:39 PM, you wrote:
>
> k> I am so far using japanese characters with mysql without any problem.
>
> k> But today when I try to insert some japanese characters, only one
character
> k> get truncated to a . (dot) mark.
>
> k> How can I set the default charset in the .cnf or .ini file ?
>
> [mysqld]
> dafault-character-set=#
>
> k> With MyISAM, I used to set in the mysql admin.
> k> Now I am not using MySQL admin with innodb
>
>
>
> --
> For technical support contracts, goto
https://order.mysql.com/?ref=ma02-010c
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.com
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
