Pradeep, Check the ANSI SQL standard (SQL-92 *). The double-quote is the ANSI quoted identifier for object identifiers. The single-quote is the prefix and suffix for literals. So, Quote_Prefix and Quote_Suffix are correct for both Oracle and SQL Server (DB2 as well...)
Thanks, David * http://www.andrew.cmu.edu/user/shadow/sql/sql1992.txt Pradeep Tapadiya wrote:
NETters, If you have a sql query that has spaces in the table name or the column name, you need to qualify them using identifier quotes. For example, this quote prefix and suffix for SQLServer are "[" and "]" respectively. OLEDB supports a mechanism to get this metadata using SQL_IDENTIFIER_QUOTE_CHAR. The facility to get metdata was not available in .NET 1.1 but now is available in .NET 2.0. However, I don't see a way to get the identifier quotes using OleDBLiteral enumeration. When queried, I see that we can get "Quote_Prefix" and "Quote_Suffix." Both SQLServer and Oracle are returning double quotes for these values, which obviously is not right. I think this is used for literal quotes and not identifier quotes. I would appreciate it if someone can enlighten me on what I missed. Thank you in advance for your help. Pradeep
=================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
