Installation and Upgrade Guides › Policy Server Installation Guide › Configuring the Policy Server for an International Environment › Configure SiteMinder Data Stores Supporting International Characters › Configure a Japanese User Store in Oracle

Configure a Japanese User Store in Oracle

Using the smsampleusers_oracle.sql file installed with the Policy Server, you can configure a user store in an Oracle database. This file is installed in the <siteminder_installation>\db\SQL directory.

Note: User stores are not limited to UTF-8 format. You can create a user store in the local character set encoding.

To configure a Japanese user store in Oracle

1. Create a database for the user data that supports Oracle's UTF-8 NLS_CHARACTERSET encoding.
2. Using Oracle's SQL-Plus, import the smsampleusers_oracle.sql file.

   Note: More information on importing the smssampleusers_oracle.sql file exists in Sample User Directories. Be aware that if you are inserting Japanese characters, import the file from a Japanese operating system.

   The user store configuration is complete.