SQL server returns . as . not _ !

arnaro

Hi,

ran into a strange "problem" today. Ever since I started writing c# code against SQL server Navision databases I've had to replace . with _ such as "No." would be "No_".

Then today while installing at a client all off a sudden the SQL Server doesnt want the "No_" but gladly accepts "No." !!!!

Is there a setting on the server that does this or does anyone know how to tackle this otherwise than changing all the sql queries to use . instead of _ ?

Regards

ara3n

I've never changed this setting but on file->database->alter->Integration Tab

You will find remove characters text box


Is the Convert identifiers checked?

Marije_Brummel

It is in the NAV setup under alter database.

Reallly do not change it. We have some customers (3 if I am not mistaken) who have that running and it is a nightmare. SQL officialy does not support it. You can run into all kinds of ugly supprises.

arnaro

Yes - I decided to change the SQL syntax rather than taking the chance on changing the server as this has to be up at all times.

Thanks for the help tough - at least I know the cause now.