Junk charecter in SQL Server 2000 varchar

[Former Member]

Hi all,

My application works with both SQL Server as well as Oracle.For SQL Server 2000 to create primary key in to one table i am using UuidCreate() function which returns unique key of length 32.But in case of SQL Server 2000, it some times accepts junk charecters. For Oracle database with this function i am not gettng any error,But SQL Server sometime accepts junk charecter.The data type used for that column is varchar.Can you please suggest me the root cause of it and solution for it.

Thanks in advance,

Anjela

[markus_doehr2]

Are you doing that in a SAP application or in a self written one? In the latter case this is the wrong forum...

--

Markus