Issue 69270 - German Umlauts in postgresql table mangled
Summary: German Umlauts in postgresql table mangled
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: PC Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-09-05 12:08 UTC by rkollien
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description rkollien 2006-09-05 12:08:16 UTC 
I access a table in a postgresql database via the unixODBC driver. Some cells in
the table contain values with german Umlauts (ä,ö,ü....). When i use the
datasource with OOo 2.0.3, than the Umlauts geht mangled (seems they are
represented as a "double-character"). When accessing the postgresql table with
other tools like knoda, rekall or pgaccess, the characters are displayed
correctly. All OOo components (Writer, Base, Calc) show invalid characters.
Unfortunately unlike in version 1.1.x of OOo, in the 2.x there is no "Character
Set" option in the datasource dialog any more.

Just to be sure: i speak from the content of a cell, not the row headers!
Comment 1 rkollien 2006-10-16 17:54:02 UTC 
After a long journey through the options in base i found the character set
option. Not very user friendly, but existent.
Comment 2 christoph.lukasiak 2006-10-23 14:46:33 UTC 
clu->rkollien: 1. does that fix your problem? 2. if you miss any info in the
help or find dialogues not good usuable or pretty hidden, please write issues /
feature enhancements for such cases to improve the oo (it will also help others)

thx
Comment 3 rkollien 2006-10-23 15:08:17 UTC 
1. Yes, this solves my problem.
2. Now in 2.0.4 i found the "characterset" keyword ("Zeichensatz" in the german
translation). Now this is ok too. Great work at all.