pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedencoding
6+ messages / 4 participants
[nested] [flat]
* encoding
@ 2005-05-06 13:50 Joel Fradkin <jfradkin@wazagua.com>
0 siblings, 1 reply; 6+ messages in thread
From: Joel Fradkin @ 2005-05-06 13:50 UTC (permalink / raw)
To: pgsql-sql
I am not clear on what makes this work?
I am going live Sunday and have thus far been using SQL_ASCHII.
I still have the feeling I should be using something else, but when I used
Unicode my conversion from MSSQL blew up on encoding error for a char that
wasn't plain ASCHII(IE French or Spanish etc.).
The conversion program ran fine when I chose SQL_ASCHII.
The data is on a windows 2k MSSQL database.
The conversion program is a .net app that reads from MSSQL win2k data base
and writes to postgtres 8.0.2 on Redhat AS4.
I tried to get this to work a while back and found if I set the encoding
explicitly on the connect in the .net connector it did not give me an error,
but I still have many asp pages and I could not get the encoding set using
the ODBC (which is what the asp pages use).
I believe I tried setting it with a sql statement, but that did not seem to
help either.
I can move forward using SQL_ASCHII, but would prefer to have encoding set
properly, but I ma not sure what I am missing.
Any ideas would be much appreciated.
Joel Fradkin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: encoding
@ 2005-05-07 16:32 Aarni Ruuhimäki <aarni@kymi.com>
parent: Joel Fradkin <jfradkin@wazagua.com>
0 siblings, 1 reply; 6+ messages in thread
From: Aarni Ruuhimäki @ 2005-05-07 16:32 UTC (permalink / raw)
To: Joel Fradkin <jfradkin@wazagua.com>; +Cc: pgsql-sql
Hi,
In my experience , I think your best bet and an all-around good general
encoding to use is latin1, which copes with l'accent egys & graves, umlauts,
harasoos and others.
Not so sure about the M$-import stuff though. Or asp or .net. Read the Gates
Private Licence ...
You might also want (re?)configure your Pg-system with --enable-locale and set
your preferred locale and db default encoding in initdb to suit your needs,
in order to have alphabetical sortings etc. work ok.
BR,
Aarni
On Friday 06 May 2005 16:50, you wrote:
> I am not clear on what makes this work?
>
>
>
> I am going live Sunday and have thus far been using SQL_ASCHII.
>
> I still have the feeling I should be using something else, but when I used
> Unicode my conversion from MSSQL blew up on encoding error for a char that
> wasn't plain ASCHII(IE French or Spanish etc.).
>
> The conversion program ran fine when I chose SQL_ASCHII.
>
> The data is on a windows 2k MSSQL database.
>
> The conversion program is a .net app that reads from MSSQL win2k data base
> and writes to postgtres 8.0.2 on Redhat AS4.
>
> I tried to get this to work a while back and found if I set the encoding
> explicitly on the connect in the .net connector it did not give me an
> error, but I still have many asp pages and I could not get the encoding set
> using the ODBC (which is what the asp pages use).
>
> I believe I tried setting it with a sql statement, but that did not seem to
> help either.
>
> I can move forward using SQL_ASCHII, but would prefer to have encoding set
> properly, but I ma not sure what I am missing.
>
>
>
> Any ideas would be much appreciated.
>
>
>
> Joel Fradkin
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: encoding
@ 2005-05-07 20:54 Peter Eisentraut <peter_e@gmx.net>
parent: Aarni Ruuhimäki <aarni@kymi.com>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2005-05-07 20:54 UTC (permalink / raw)
To: aarni@kymi.com; +Cc: Joel Fradkin <jfradkin@wazagua.com>; pgsql-sql
Aarni Ruuhimäki wrote:
> You might also want (re?)configure your Pg-system with
> --enable-locale and set your preferred locale and db default encoding
> in initdb to suit your needs, in order to have alphabetical sortings
> etc. work ok.
If you're still using a PostgreSQL version that has the --enable-locale
option then you rather need to upgrade.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: encoding
@ 2005-05-08 11:59 Aarni Ruuhimäki <aarni@kymi.com>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Aarni Ruuhimäki @ 2005-05-08 11:59 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-sql
Hi,
And excuse me ?
[root@kymifedora3_test postgresql-8.0.2]# ./configure --enable-locale
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support...
BR,
Aarni
On Saturday 07 May 2005 23:54, you wrote:
> Aarni Ruuhimäki wrote:
> > You might also want (re?)configure your Pg-system with
> > --enable-locale and set your preferred locale and db default encoding
> > in initdb to suit your needs, in order to have alphabetical sortings
> > etc. work ok.
>
> If you're still using a PostgreSQL version that has the --enable-locale
> option then you rather need to upgrade.
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: encoding
@ 2005-05-08 16:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Aarni Ruuhimäki <aarni@kymi.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2005-05-08 16:43 UTC (permalink / raw)
To: aarni@kymi.com; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-sql
Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni@kymi.com> writes:
>> If you're still using a PostgreSQL version that has the --enable-locale
>> option then you rather need to upgrade.
> And excuse me ?
> [root@kymifedora3_test postgresql-8.0.2]# ./configure --enable-locale
> checking build system type... i686-pc-linux-gnu
Proves nothing, since configure scripts ignore unrecognized --enable
and --with options. (The Autoconf boys steadfastly maintain that
that's a feature not a bug, but I disagree.)
The more relevant check is "configure --help | grep locale"
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: encoding
@ 2005-05-08 17:20 Aarni Ruuhimäki <aarni@kymi.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Aarni Ruuhimäki @ 2005-05-08 17:20 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Ain't trying to prove no one no thing.
So sorry.
Thamks.
On Sunday 08 May 2005 19:43, you wrote:
> Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni@kymi.com> writes:
> >> If you're still using a PostgreSQL version that has the --enable-locale
> >> option then you rather need to upgrade.
> >
> > And excuse me ?
> >
> > [root@kymifedora3_test postgresql-8.0.2]# ./configure --enable-locale
> > checking build system type... i686-pc-linux-gnu
>
> Proves nothing, since configure scripts ignore unrecognized --enable
> and --with options. (The Autoconf boys steadfastly maintain that
> that's a feature not a bug, but I disagree.)
>
> The more relevant check is "configure --help | grep locale"
>
> regards, tom lane
--
Aarni Ruuhimäki
Megative Tmi
Pääsintie 26
45100 Kouvola
Finland
+358-5-3755035
+358-50-4910037
www.kymi.com | cfm.kymi.com
--------------
This is a bugfree broadcast to you
from **Kmail**
on **Fedora Core 2** linux system
--------------
Linux is like a wigwam - no windows, no gates and a free apache inside.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2005-05-08 17:20 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-06 13:50 encoding Joel Fradkin <jfradkin@wazagua.com>
2005-05-07 16:32 ` Aarni Ruuhimäki <aarni@kymi.com>
2005-05-07 20:54 ` Peter Eisentraut <peter_e@gmx.net>
2005-05-08 11:59 ` Aarni Ruuhimäki <aarni@kymi.com>
2005-05-08 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-05-08 17:20 ` Aarni Ruuhimäki <aarni@kymi.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox