Unicode or Non-Unicode on database level

[Former Member]

Hello,

where can I identify whether my SAP System is Unicode or Non-Unicode

on database level ?

Best regards

Alex

[JPReyes · Accepted solution]

Simply check the DB character set

Regards

Juan

[Former Member · Accepted solution]

Hello Juan,

did you mean the "Collation" ?

Is anywhere in the tables an entry where can I identify the Unicode or Non-Unicode

capabilities of the SAP system for example the UCCHECK or somethin else ?

Best regards

Alex

[JPReyes · Accepted solution]

No, I ment check the environmental variables and check the NLS_LANG variable.

Regards

Juan

[Former Member · Accepted solution]

Go to sm51 and click on release notes, that should give you your SAP systems status.

Thanks!

Rahul Dwivedi.

[Former Member · Accepted solution]

Hello Rahul,

When I don`t have acces to the SAP System ? or when the the System doesn`t start ?

I only have acces to the Database.

The OS (W2k3) and database (MSSQL 2000) are unicode compatible .

I only want to know where I can directly identify if the SAP System ist Unicode or Non-Unicode on

database level.

Best regards

Alex

[clas_hortien · Accepted solution]

Hi,

just do a sp_help on any table with a character field. If the datatype is varchar it is non-unicode, if it is nvarchar it is unicode.

use <SID>

setuser '<sid>'

go

exec sp_help T000

go

Name Owner

-

---

-

---

T000 roy

Column_name Type

-

---

-

---

MANDT nvarchar

MTEXT nvarchar

ORT01 nvarchar

MWAER nvarchar

ADRNR nvarchar

CCCATEGORY nvarchar

CCCORACTIV nvarchar

CCNOCLIIND nvarchar

==> is unicode

Regards

Clas

[Former Member · Accepted solution]

Thanks Clas.

Problem solved.

[clas_hortien · Accepted solution]

Hi,

I'm happy that I was able to help you.

Please keep in mind, when you opened the case and you got an answer to your problem, please provide points and close the case.

Many thanks

Clas