[EMAIL PROTECTED] wrote:
Only ASCII values store more space efficiently in UTF-8. All values
over 127 store more space efficiently using UTF-16.
This second statement is demonstrably not true. Only values above 0x07ff
require more than 2 bytes in UTF-8. All chars up to that point are
stored in UTF-8 with greater or equal efficiency than that of UTF-16.
See http://www.zvon.org/tmRFC/RFC2279/Output/chapter2.html
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match