Apache OpenOffice (AOO) Bugzilla – Issue 20646
unixODBC access
Last modified: 2010-11-11 04:03:09 UTC
MySQL, UTF8: OOo doesn't allow edit data in tables. PostgreSQL, UTF8: Inserting ASCII symbol like ".", ",", ";" after multibyte symbol (Russian, Arabic etc.) crashes OOo
correcting sub component (see http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access, please), and default owner
hi cezg, can you please provide a step by step description what I have to do to reproduce this. bye Marc
8<----------------------------------------------------------------- [peet@mysql peet]$ locale LANG=ru_RU.KOI8-R LC_CTYPE=ru_RU.KOI8-R LC_NUMERIC=ru_RU.KOI8-R LC_TIME=ru_RU.KOI8-R LC_COLLATE=ru_RU.KOI8-R LC_MONETARY=ru_RU.KOI8-R LC_MESSAGES=ru_RU.KOI8-R LC_PAPER="ru_RU.KOI8-R" LC_NAME="ru_RU.KOI8-R" LC_ADDRESS="ru_RU.KOI8-R" LC_TELEPHONE="ru_RU.KOI8-R" LC_MEASUREMENT="ru_RU.KOI8-R" LC_IDENTIFICATION="ru_RU.KOI8-R" LC_ALL= [peet@mysql peet]$ rpm -qa | grep -i libunixodbc libunixODBC-2.2.3-alt1 [peet@mysql peet]$ rpm -qa | grep postgresql-server postgresql-server-7.3.4-alt2 [peet@mysql peet]$ cat .odbc.ini [mysql] Driver = /usr/lib/libmyodbc3.so Trace = No TraceFile = Host = localhost Port = 3306 Socket = Database = peet User = peet Password = ****** [unicode] Description = PostgreSQL Driver = PostgreSQL Trace = No TraceFile = Database = unicode Servername = localhost UserName = peet Password = ******** Port = 5432 Protocol = 6.4 ReadOnly = No RowVersioning = Yes ShowSystemTables = No ShowOidColumn = No FakeOidIndex = No ConnSettings = [peet@mysql peet]$ LC_ALL=UTF-8 psql Password: Welcome to psql 7.3.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit unicode=# \l List of databases Name | Owner | Encoding -----------+----------+----------- template0 | postgres | SQL_ASCII template1 | postgres | SQL_ASCII unicode | peet | UNICODE (3 rows) unicode=# \dt List of relations Schema | Name | Type | Owner --------+--------+-------+------- public | biblio | table | peet (1 row) unicode=# \d biblio Table "public.biblio" Column | Type | Modifiers ------------+------+----------- identifier | text | not null type | text | address | text | annote | text | author | text | booktitle | text | chapter | text | edition | text | editor | text | howpublish | text | institutn | text | journal | text | month | text | note | text | number | text | organizat | text | pages | text | publisher | text | school | text | series | text | title | text | reptype | text | volume | text | year | text | url | text | custom1 | text | custom2 | text | custom3 | text | custom4 | text | custom5 | text | isbn | text | Indexes: biblio_pkey primary key btree (identifier) [peet@mysql jdbc]$ mysql -p -D peet Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 81612 to server version: 3.23.56 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> describe bala; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | id | varchar(11) | | PRI | | | | text | varchar(255) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) mysql> 8<----------------------------------------------------------------- OpenOffice: 1) Data Sources -> New -> ODBC (postgresql connection) -> Character set Unicode (UTF-8) Open Database access gui, open connection, insert data in the biblio.identifier data like "А.Б.Балала, и так далее" (in Russian), commit row. OOo crashes. Note: database character set is unimportant. 2) Data Sources -> New -> ODBC (mysql connection) -> Character set Unicode (UTF-8) Open Database access gui, open connection. Table date is unupdateable.
In postgresql input above, symbols "А.Б.Балала..." must be replaced with appropriate Russian analogs, in this example. But inserting any non-ASCII characters in conjunction with ".", "," and spaces also crashes OOo.
Hi, in OOo 1.1.1. which will be available soon there is a crash bugfix about UTF characters in ODBC database cconnections. So this issue will be fixed in OOo 1.1.1. I close this issue now. If this issue is not fixed in OOo 1.1.1 which will be avilable soon, please feel free to reopen this issue. Bye Marc
close issue
change subcomponent to 'none'
Created attachment 74198