Ask the Expert

Understanding current database character set

How can I find out about the details of my current database character set?

    Requires Free Membership to View

Your current database character set can be easily deterimined by querying the database as follows:
select property_name,property_value
from database_properties where property_name like '%CHARACTERSET%';

If you want to know more about your specific character sets, you'll have to look up that information in the Oracle documentation.

This was first published in May 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: