Hmmmmm, I'm using osx 10.6.6 and I compiled PG myself from source. Is there any configure option or any library I may use to get the correct behavior? Is there any runtime setting I can make to change this tolower() behavior, maybe skip the call?
Thanks in advance. -- Sent from my Android phone Francisco Figueiredo Jr. Npgsql lead developer fxjr.blogspot.com twitter.com/franciscojunior Em 18/03/2011 22:01, "Tom Lane" <t...@sss.pgh.pa.us> escreveu: > "Francisco Figueiredo Jr." <franci...@npgsql.org> writes: >> My database has encoding set to UTF-8 although my lc_collate is pt.BR.UTF-8 >> this lc setting my have cause some trouble? > > Hmmm ... actually, it strikes me that this may be a downcasing problem. > PG will try to feed an unquoted identifier through tolower(), and that > basically can't work on multibyte characters. Most implementations of > tolower() are smart enough to not change high-bit-set bytes in UTF8 > locales, but maybe your platform's is not ... > > regards, tom lane