https://bugs.documentfoundation.org/show_bug.cgi?id=104905
--- Comment #7 from Lionel Elie Mamane <[email protected]> ---
(In reply to robert from comment #5)
> Have tried to create a table with direct SQL as defined above. The following
> error appeared.
> COLLATION DE_DE for CHARACTER SET NONE is not defined
Looks like you need to set a character set _and_ a character set. You have
"NONE" as character set, need "UTF8" or "ISO8859_1". E.g.:
CREATE TABLE users (
"NAME" VARCHAR(50) CHARACTER SET UTF8 COLLATE UNICODE,
...
);
Possibly we should just set:
* default character set UTF8 at the database level when it is created
* UNICODE collation by default when the table is created through GUI (unless
we can set that at database level, too?)
Let's first finish this through (see if it works...) and see about setting the
default then.
(In reply to robert from comment #6)
> (In reply to Lionel Elie Mamane from comment #4)
> > And collation, also. Try:
> > SELECT "Name", LOWER ( "Name" COLLATE UNICODE ) FROM "Table2"
> > SELECT "Name", LOWER ( "Name" COLLATE DE_DE ) FROM "Table2"
> > SELECT "Name", LOWER ( "Name" COLLATE UTF-8 ) FROM "Table2"
>
> Changing a query like this gives:
> COLLATION UTF for CHARACTER SET NONE is not defined
> ... for every collation. And a query like this won't work in GUI, only
> direct SQL, so the query couldn't be used for input or changing data any
> more.
I think if the character set / collation are set at the table (or database
level), the query will work without an explicit collation. I'm just trying to
make a test here.
_After_ setting the character set, maybe
SELECT "Name", LOWER ( "Name" COLLATE 'UTF-8' ) FROM "Table2"
will work better (quotes around UTF-8).
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
