469,645 Members | 1,174 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

MySQL character set and character length

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.

Jul 19 '05 #1
0 1907

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Martin Lucas-Smith | last post: by
4 posts views Thread by Aditya Ivaturi | last post: by
7 posts views Thread by Randell D. | last post: by
1 post views Thread by Bert Sierra | last post: by
1 post views Thread by Ike | last post: by
reply views Thread by rabbit | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.