-
In your list of countries you don't have any double-byte or "special" language not covered by the normal "Western Europe and United States" countries (regional settings). If you don't expect to include such countries the recommendation would be Windows collation Danish_Norweighan...
-
Tack ska du ha Erik :) (Thank you Erik) If I have understand this correct we should use SQL Collation on the new database, the thing is that today on the Navtive databases we have been using CodePage 437 from the start 6 years ago. Should I use SQL_Latin1_General_CP437_CS_AS. My thought here is that...
-
We had the same question as we have a setup much like yours. Our only additional requirement is that we need to be able to support double byte character sets also. Here are there recommendations we received by our consultant: As promised hereby the conclusions based on my test of windows collations and...
-
Hi all! Im in the progress to create a new database for a company that is located all around europe (Sweden, Denmark, Norway, France, Netherland, Belgium and Austria) does anyone know what collation I should use in order to be able to enter the correct characters in Navision? They all will share one...
-
[Noget nyt i sagen?] Ikke andet - en jeg har konverter til "Scandinavian dictrionary sort order, code page 850, case-sensitive (59) " for at få den rigtigt sotering på klienterne, også taget højde for det i alle andre forespørgsler. - Linket fra "ohlfert" giver en rigtigt god forklaring...
-
quote: Hvilket 'Collation' bruger du lige nu? Den du har sagt - 59 - er en gammel 'SQL Collation' og du bør ungå dem hvis du kan. Brug en 'Windows Collation' i stedet for. Du har ret. Det var ikke smart med den Collation, efter lidt test fik jeg en masse prb. med andre data kilder...
-
Fortæller det her link noget der kan bruges: http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_frm/thread/2287830cd01ef00a/e07836e0f42bac33?lnk=st&q=%22sql+server%22+%22aa%22+select&rnum=25&hl=en#e07836e0f42bac33
-
Hvilket 'Collation' bruger du lige nu? Den du har sagt - 59 - er en gammel 'SQL Collation' og du bør ungå dem hvis du kan. Brug en 'Windows Collation' i stedet for. Undskyd mit Dansk.
-
Hej! .. den var sat til Windows-Sortering - Valider tegntabel Sorteringsbeskrivelse Danish, Norwegian Forskel på Store og Små bogst. - Forskel på accenter /HCN
-
Ok så det var en windows collation du fik problemet med. Hvis du prøver uden '@', ligseom "*Aase*", finder det noget?