On Sun, Apr 26, 2015 at 5:02 PM, Bjørn T Johansen wrote:
And my problem is that I am using Norwegian in some tables and when using
order by the sort order is not correct for the Norwegian letters..
So my guestion is if it is possible to get the correct sort order without
recreating all my
On Sun, 26 Apr 2015 10:31:37 +0200
Gunnar \Nick\ Bluth gunnar.bl...@pro-open.de wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
My databases looks like this...:
List of databases Name |Owner | Encoding | Collate
My databases looks like this...:
List of databases
Name |Owner | Encoding | Collate |Ctype| Access
privileges
--+--+--+-+-+---
dbname | owner
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
My databases looks like this...:
List of databases Name |Owner | Encoding | Collate
|Ctype| Access privileges
On Sun, 26 Apr 2015 10:59:10 +0200
Bjørn T Johansen b...@havleik.no wrote:
On Sun, 26 Apr 2015 10:31:37 +0200
Gunnar \Nick\ Bluth gunnar.bl...@pro-open.de wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
My databases looks like
On Sun, 26 Apr 2015 11:48:37 +0200
Oliver Elphick o...@lfix.co.uk wrote:
On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote:
Ok, tried to run:
alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8
But I just get:
[Error Code: 0, SQL State: 42601] ERROR:
On Sun, 2015-04-26 at 11:09 +0200, Bjørn T Johansen wrote:
Ok, tried to run:
alter table medlem alter column fornavn varchar(50) collate nb_NO.utf8
But I just get:
[Error Code: 0, SQL State: 42601] ERROR: syntax error at or near varchar
(tried without the varchar also..)
ALTER [
On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote:
CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8)
But then I get this:
ERROR: could not create locale nb_no.utf8: No such file or
directory
DETAIL: The operating system could not find any locale data for the
locale name
On Sun, 26 Apr 2015 12:43:57 +0200
Oliver Elphick o...@lfix.co.uk wrote:
On Sun, 2015-04-26 at 12:39 +0200, Bjørn T Johansen wrote:
CREATE COLLATION nb_NO (LOCALE = nb_NO.utf8)
But then I get this:
ERROR: could not create locale nb_no.utf8: No such file or
directory
DETAIL:
Hi all,
I have a table TranslationDictionary in a database initalized with
lc_collation and lc_type de-de .
In the table is the value 'Straße' and I can't insert 'Strasse', but
when I try to create a foreign key on this table, the value 'Strasse' in
the foreign table is unmatched.
Is this a
10 matches
Mail list logo