On Sun, 26 Apr 2015 12:43:57 +0200
Oliver Elphick 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
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 11:48:37 +0200
Oliver Elphick 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..)
ALT
On Sun, 26 Apr 2015 10:59:10 +0200
Bjørn T Johansen wrote:
> On Sun, 26 Apr 2015 10:31:37 +0200
> "Gunnar \"Nick\" Bluth" wrote:
>
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Am 26.04.2015 um 10:02 schrieb Bjørn T Johansen:
> > > My databases looks like this...:
> > >
> > >
On Sun, 26 Apr 2015 10:31:37 +0200
"Gunnar \"Nick\" Bluth" 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
> > |Ct
-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, 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
My databases looks like this...:
List of databases
Name |Owner | Encoding | Collate |Ctype| Access
privileges
--+--+--+-+-+---
dbname | owner
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 bug,
10 matches
Mail list logo
