JDBC ODBC text problem
От | Allan Huffman |
---|---|
Тема | JDBC ODBC text problem |
Дата | |
Msg-id | 38042599.75433A1C@ppc.pims.org обсуждение исходный текст |
Список | pgsql-interfaces |
resent message with JDBC ODBC in the subject Dear Fellow Developers and Hackers, After installing PostgreSQL 6.5.2 (on my Sparc 7) and configured as follows: --with-mb=UNICODE I am getting a truncation of some varchar columns. When accessing a PostgreSQL table1. I get this error in my postmaster window: ERROR: Conversion between UNICODE and SQL_ASCII is not supported And this error in my DOS window (which Visual Café Database Edition ises to run applets from): The maximum width size for column 2 is: 17 table1: +---------------------------------------+ ! Field ! Type ! Length ! +--------------------------------------+ ! data_code ! varchar() ! 15 ! ! data_field ! varchar() ! 43 ! +--------------------------------------+ >From my PC Java GUI, running in Visual Café, I am able to enter a full 15 character string into data_code but I get the following error when I try to enter a 43 (or greater than 17) character string into data_field: Invalid value for the column data and it truncates the data I enter to 17 characters. >From a psql prompt on the same Sun that is running the postmaster I can change the table without the truncation and no mention of UNICODE! ( For example: +__________________________________________________________________________+ Without UNICODE configured I got the following errors: >From the Postmaster: "ERROR: MultiByte strings (MB) must be enabled to use this function. " >From Visual Café: "The maximum width size for column 2 is: 17" +__________________________________________________________________________+ Any suggestion will be greatly appreciated, even a work around. Sincerely, Allan
В списке pgsql-interfaces по дате отправления: