Re: [GENERAL] Knowing the length(convert(username using windows_1251_to_utf8))

2007-01-11 Thread Martijn van Oosterhout
On Thu, Jan 11, 2007 at 12:37:32PM +0100, Alexander Farber wrote: > May I ask you an off-topic question? I've read several > docs on Unicode, but they are difficult to understand. Have you read the Unicode FAQ? http://www.cl.cam.ac.uk/~mgk25/unicode.html > Do you think that an UTF8 string will e

Re: [GENERAL] Knowing the length(convert(username using windows_1251_to_utf8))

2007-01-11 Thread Alexander Farber
Hi Martijn, On 1/11/07, Martijn van Oosterhout wrote: If you need the string in UTF-8, why not just set the "client_encoding" to "utf8" and then the server will only send you strings in utf8, not conversion necessary. actually you are right, because I need all my data in UTF8 anyway (for a we

Re: [GENERAL] Knowing the length(convert(username using windows_1251_to_utf8))

2007-01-11 Thread Martijn van Oosterhout
On Thu, Jan 11, 2007 at 10:19:38AM +0100, Alexander Farber wrote: > Hello PostgreSQL users! > > I have this data stored in WIN1251 encoding, which > is being fetched by a libpq application I'm developing: > phpbb=> select username, length(username), length(convert(username > using windows_1251_

Re: [GENERAL] Knowing the length(convert(username using windows_1251_to_utf8))

2007-01-11 Thread Alexander Farber
And additional question please: Can I still be sure that the data returned in the convert(username using windows_1251_to_utf8) column will be 0-terminated or should I fetch the data length using PQgetlength and maintain that value in my C-program? Thank you Alex On 1/11/07, Alexander Farber <[E

[GENERAL] Knowing the length(convert(username using windows_1251_to_utf8))

2007-01-11 Thread Alexander Farber
Hello PostgreSQL users! I have this data stored in WIN1251 encoding, which is being fetched by a libpq application I'm developing: phpbb=> show client_encoding; - WIN1251 (1 row) phpbb=> \d phpbb_users; username | character varying(25) | not null default '