Getting Unicode characters greater than or equal to 0x10000 are not supported error

Started by Venkiover 21 years ago3 messages

Venki@insoft.com

over 21 years ago

2 attachment(s)

Hi All,
I am using Postgres 7.4.6 on Red hat linux 9.0. When I try insert a chinese
character from my frontend(Asp.Net on win2k pro using ado.net, .Net
framework 1.1) into a table in my postgres database I am getting the
following error message

"System.Data.Odbc.OdbcException: ERROR [HY000] ERROR: Unicode characters
greater than or equal to 0x10000 are not supported"

I have created the database with the encoding "UNICODE" since the
application needs to be multilingual.

Does Postgres 7.4.6 supports unicode?

Can anyone in the list help me with a solution?

Thanks in Advance

--
Kind Regards,
Venki
Jr. Project Manager
Insoft.com Pvt. Ltd.
India: +91 44 24464292
Venki@Insoft.com / www.insoft.com

Attachments:

IMSTP.gifimage/gif; name=IMSTP.gifDownload

BackGrnd.jpgimage/jpeg; name=BackGrnd.jpgDownload

����JFIFdd��Ducky��!Adobed�������
#%'%#//33//@@@@@@@@@@@@@@@&&0##0+.'''.+550055@@?@@@@@@@@@@@@��es"���!1A"@20P!1AQaq������2��P���E����`Q����.h\�P�D��P%�J&��"�jP��Q@Q5�Xb(Q5�Xf��J 4���������������������������
mQ��K-6���b K����]b��8�3_��z�o+�t����h}iD1T,���ji�6'�
Bf��T�vU
�|�]!
Rb�V�j	>H�e�q�Q�]�?$���(sU;)�F[�q��:��������@fulH���f�RSup��!����)}X���M<&�Z�������(��R����>���_�����j�c���f�������#������\�����Y��c10���y������?c��?c��?{���oP_"Di�~��@B��qA���y���	)�\��f,?��L��@V����%D8�WS���11��N����L������y��o������)`,�w��sy�AS��.�E�3H���
�.�B�@7]�q�y�8s����V��a��#�Z�����0��2���S����z����}Lg���?p��#ut1
�q3��3�e$��~�:�%~ �G�cY�P�x3��b�������
�����f���!���F��Ci
��
$"4e�u��:c�{X�7����y��5��d��0+�	��y��? Y�z����$C���*����H�]���;��w�������#� ��}��[��A�[�sG���0�<��
5��	M�0��\�>�s��e��G&�f�}4� y���V*`"����*+P�����rf�4�<�������v���"��"�+:^K���e_�zo����#>��y�'zfy�g���zQ-
�0�/ �"DM~L�pF&@���������	�|C���H]�p���L������P�7\�G�Y���A�X��F�a �1
U��c1U������G<k��:���\/�iC�M����/���������5w��*z�O��

Richard Huxton

dev@archonet.com

about 21 years ago

In reply to: Venki (#1)

Re: Getting Unicode characters greater than or equal to

Venki wrote:

Hi All,
I am using Postgres 7.4.6 on Red hat linux 9.0. When I try insert a chinese
character from my frontend(Asp.Net on win2k pro using ado.net, .Net
framework 1.1) into a table in my postgres database I am getting the
following error message

"System.Data.Odbc.OdbcException: ERROR [HY000] ERROR: Unicode characters
greater than or equal to 0x10000 are not supported"

Hi Venki

This isn't really the right list for support questions, you might be
better off with the general or odbc lists.

In your case I'm guessing your Windows system isn't supplying UTF-8 but
some other character set. Certainly that is what the error message
implies. Note PG handles UTF-8 but not UTF-16 or other encodings.

HTH
--
Richard Huxton
Archonet Ltd

John Hansen

john@geeknet.com.au

about 21 years ago

In reply to: Richard Huxton (#2)

Re: Getting Unicode characters greater than or equal to

In your case I'm guessing your Windows system isn't supplying
UTF-8 but some other character set. Certainly that is what
the error message implies. Note PG handles UTF-8 but not
UTF-16 or other encodings.

Actually, Chinese is a problem on any pg version if the db encoding is
unicode, since pg currently does not support UTF8 characters above
0x10000

See my previous post
http://archives.postgresql.org/pgsql-patches/2004-11/msg00259.php

... John

Import Notes

Resolved by subject fallback