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 som skrive til de SQL tabeller. Selv om de er af samme Collation som der skrives med på Navision SQL Databasen, det virker bare ikke hvis man ikke sætter den op til Windows Collation. /HC Filed under: Navision, SQL Server 2000, Navision 3.70, SQL Server, Collation Posts 808 5,920 Points Joined: Jul 3, 2001 Last Online: Feb 2, 2010 19:23 Location: Vedbæk, Denmark Reply Dean McCrae replied on Oct 17, 2005 9:16 How helpful was this comment/solution? Please rate here: rated by 0 users Ok så det var en windows collation du fik problemet med. Hvis du prøver uden '@', ligseom "*Aase*", finder det noget? This posting is provided "AS IS" with no warranties, and confers no rights. Filed under: Navision, SQL Server 2000, Navision 3.70, SQL Server, Collation Posts 111 650 Points Joined: Mar 2, 2001 Last Online: Mar 13, 2007 4:25 Location: Kolding, Jylland Denmark Reply Allan Ohlfsen replied on Oct 17, 2005 14:08 How helpful was this comment/solution? Please rate here: rated by 0 users 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 Filed under: Navision, SQL Server 2000, Navision 3.70, SQL Server, Collation Posts 439 2,675 Points Joined: Feb 8, 2000 Last Online: Mar 12, 2008 23:49 Location: Simi Valley, CA (Near Los Angeles) Reply Henrik Helgesen replied on Dec 5, 2005 8:48 How helpful was this comment/solution? Please rate here: rated by 0 users Noget nyt i sagen? Henrik Helgesen, Navision Developer since 1995 LinkedIn profile @ http://helgesen.info | My website @ http://helgesen.us Filed under: Navision, SQL Server 2000, Navision 3.70, SQL Server, Collation Posts 14 115 Points Joined: Jan 1, 2002 Last Online: Mar 10, 2010 15:24 Location: Næstved, Sjælland Denmark Reply hcn replied on Feb 3, 2006 5:00 How helpful was this comment/solution? Please rate here: rated by 0 users [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 på selve problemet. /HC Filed under: Navision, SQL Server 2000, Navision 3.70, SQL Server, Collation Previous | Next Page 1 of 1 (12 items) | Get this RSS feed | Related Posts Navision Attain 3.70 (Runtime) og SQL 2000 , Posted to Dansk Dynamics Forum (Danish Dynamics Forum) Re: Navision Attain 3.70 (Runtime) og SQL 2000 , Posted to Dansk Dynamics Forum (Danish Dynamics Forum) Re: Navision Attain 3.70 (Runtime) og SQL 2000 , Posted to Dansk Dynamics Forum (Danish Dynamics Forum) Re: Navision Attain 3.70 (Runtime) og SQL 2000 , Posted to Dansk Dynamics Forum (Danish Dynamics Forum) Re: Navision Attain 3.70 (Runtime) og SQL 2000 , Posted to Dansk Dynamics Forum (Danish Dynamics Forum)