Hi
I must convert some records from database.
I have table named "langset" in unicode database. When I try use command
select convert((SELECT "1" from langset where id_langset=5) using
utf_8_to_iso_8859_2)
in PGadmin, all is ok, sql return 1 record. But where i execute the same
command in li
Hello
I have 2 databases with same table. First database is in UNICODE, second in
SQL_ASCII.
4 columns from first database I must convert to:
(first column)iso8859-1,
(second column)iso8859-2,
(3-th column)iso8859-1,
(4 column)iso8859-5.
After it I must save these 4 rows in database in SQL_
Hi
New database must be in SQL_ASCII. In old database (UNICODE) are for example
2 columns. Rows from first column I must convert to ISO_8859_2 and insert it
to first column in SQL_ASCII database, and rows from second column I must
convert to IS0_8859_5 and insert to second column in SQL_ASCII d
Hi
Yes, but I must convert diffrent columns to diffrent iso-codes.
With pg_dump I can only dump all columns from database and these all columns
convert only to one iso-code.
On Fri, 17 Nov 2006 14:11:25 -0500, Travis Whitton wrote
> There might be better ways, but you could dump the data and u
Hi
I must copy rows from local database (UNICODE) to remote database SQL_ASCII
(not on local machine) with converting selected columns to iso8859_2 or
iso_8859_5. Can I make it with COPY?
On Sat, 18 Nov 2006 09:42:14 -0500, Travis Whitton wrote
> You can use the postgresql COPY command to dump
Hi
I have a table in SQL_ASCII. Clients with different language versions of
Windows can write data in tha table using different coding systems (polish,
english, cyrillic). Next i would like to convert each line of given column
to UTF8, but each row can use a different coding windows-125*.
Who
