Connecting Tech Pros Worldwide Help | Site Map

MySQL character set and character length

Bill
Guest
 
Posts: n/a
#1: Jul 20 '05
Dear All,

I have a question related to character set.

The default encoding of MySQL is latin1. So, textual data should be
interpreted as 8-bit character. Is that right?

If the default character set to , say big5, in server startup, will
MySQL interpretes all textual data as 16-bit character?

e.g. in latin1 encoding the word "hello" is stored as : hello\0 (5
characters + null terminator)

how will it be interpreted if the default encoding is changed to big5?

Will each 8-bit character be extended to 16-bit representation? Or will
2 8-bit characters combine to form 1 16-bit character?

Thanks a lot for your information.

Yours,
Bill
Closed Thread


Similar MySQL Database bytes