SQL Driver Questions

[Gabriel2010]

Hello!

Not as verse in SQL as I'd like to, but keep learning everyday.

When creating an SQL driver, two options appeared to be checked by default, "Use ANSI quoted identifiers" and "Use ANSI nulls, paddings, and Warnings check box". Should they be left alone or should they be unchecked? ANy consequences for unchecking botj?

Also, "Perform translation for character data check box" appears, same inquiry as above.

User connects remotely from another country to a Great Plains application hosted by SQL2k.

Thanks in advance!

Angel

Glad to be here!

 

[Gabriel2010]

Nada de nada?

Glad to be here!

 

[SQLBill]

First: Quoted_IDENTIFIER ON allows indentifier names to include SQL Server keywords if the identifier is included in double quotation marks, which by default is not allowed. This causes single and double quotation marks to be treated differently.

Second: ANSI nulls, paddings, and Warnings
ANSI_NULLS ON - disables SQL Server's = NULL extension
ANSI_PADDING ON - alway right-pad CHAR columns and don't trim trailing blanks that were entered in VARCHAR columns, as SQL Server would do by default
ANSI_WARNINGS ON - automatically display a warning if a truncation would occur because the target column is too small to accept a value. By default, SQL Server truncates without any warning.

I got the above from Inside Microsoft SQL Server 2000 by Kalen Delaney.

I don't remember which way I set my system up (it's been 3 years). But the above might give you an idea as to which you want to do. Check out the BOL for more information on ANSI settings.

-SQLBill