Re: Data too long for column problem

2008-10-15 Thread zjffdu
finally I have resolved this problem. I changed the setting of mysql , change the character setting from latin1 to utf8. On Oct 15, 8:56 am, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Tue, 2008-10-14 at 06:12 -0700, zjffdu wrote: > > but I found that I can not even store one Chinese wo

Re: Data too long for column problem

2008-10-14 Thread Malcolm Tredinnick
On Tue, 2008-10-14 at 06:12 -0700, zjffdu wrote: > but I found that I can not even store one Chinese word into the column > with 100 bytes capacity. Since you've provided no example of what you're actually doing, or information about what database you're using, it's impossible for us to guess at

Re: Data too long for column problem

2008-10-14 Thread Malcolm Tredinnick
On Tue, 2008-10-14 at 21:05 +0800, DULMANDAKH Sukhbaatar wrote: > chinese and some other complex or unicode characters takes more than > one byte to be stored. but as I know char(250) means 250 bytes or you > can store about 80 chinese chars if we assume 1 char takes 4 bytes. > then you need to c

Re: Data too long for column problem

2008-10-14 Thread zjffdu
but I found that I can not even store one Chinese word into the column with 100 bytes capacity. On Oct 14, 9:05 pm, "DULMANDAKH Sukhbaatar" <[EMAIL PROTECTED]> wrote: > chinese and some other complex or unicode characters takes more than > one byte to be stored. but as I know char(250) means 250

Re: Data too long for column problem

2008-10-14 Thread DULMANDAKH Sukhbaatar
chinese and some other complex or unicode characters takes more than one byte to be stored. but as I know char(250) means 250 bytes or you can store about 80 chinese chars if we assume 1 char takes 4 bytes. then you need to change model, and manually alter table column. -- Regards Dulmandakh -