From: | "Bronto" <brontos(at)hotpop(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Access97/odbcUnicode/pgsql : unable to map text field |
Date: | 2006-06-09 15:44:29 |
Message-ID: | 20060609154433.76F5024FCD12@smtp-3.hotpop.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
(Tested)Data type matching:
-----------------------------------------------
| ACCESS | POSTGRESQL |
-----------------------------------------------
| Text | Varchar(255) |
| Memo | Varchar(65535) |
| Number: Integer | Int 2 |
| Long Integer | Int 4 |
| Single | Float 4 |
| Double | Float 8 |
| Date/Time | TimeStamp |
| AutoNumber: Long | Serial |
| Yes/No (Boolean) | Int 2 |
| OLE Object | ByteA |
-----------------------------------------------
ODBC Driver Settings:
--------
|Page 1|
--------
- Check "Disable generic optimizer"
- Check "KSQO..."
- Check "Recognize unique indexes"
- Set "Unknown sizes" to "Maximum"
- Check "Text as LongVarChar"
- Set "Max Varchar" to 255
--------
|Page 2|
--------
- Check "LF <-> CR/LF conversion"
- Check "bytea as LO"
- Check "True is -1"
- Set "Int8 As" to "double"
Make sure you use the ANSI driver
Hope it helps.
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08.06.2006
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-06-09 15:53:07 | Re: Access97/odbcUnicode/pgsql : unable to map text field |
Previous Message | JGuillaume 'IoGuiX' de Rorthais | 2006-06-09 15:37:26 | Re: Access97/odbcUnicode/pgsql : unable to map text field |