How do you use COLLATE? I thought the collate only affected sort order or comparisons?
Does it also affect how the data is stored? If it does I assume it only affects which codepage is used to convert characters. This is not the same as UTF-8 encoding. I don't think there is a collation to force storage in utf-8 format.
skysailor
Member
1 Points
13 Posts
Re: utf-8 in database varchar
May 23, 2007 04:31 AM|LINK
How do you use COLLATE? I thought the collate only affected sort order or comparisons?
Does it also affect how the data is stored? If it does I assume it only affects which codepage is used to convert characters. This is not the same as UTF-8 encoding. I don't think there is a collation to force storage in utf-8 format.