Re: [BUGS] Getting weird results with unicode table...

2004-11-23 Thread Tom Lane
"David B" <[EMAIL PROTECTED]> writes: > Two possible bugs. > #1 Loading unicode data. I'm thinking that the dump file probably doesn't set client_encoding, or if it does, sets it to the wrong thing. Is the data in the dump file actually UTF8, or is it in some other encoding? > select substring

[BUGS] Getting weird results with unicode table...

2004-11-22 Thread David B
Folks, Two possible bugs. #1 Loading unicode data. #2 Doing count of data based on substring(1,1) of a col. -- #1 Loading unicode data -- I've loaded freedb database (freedb.org) into a 8.0.0 beta 4 database I created on my PC. PC is Windows XP P