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 SQL Server

Configure a Japanese User Store in SQL Server

Using the smsampleusers_sqlserver.sql file installed with the Policy Server, you can configure a user store in a SQL Server 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 SQL Server

1. Edit the smsampleusers_sqlserver.sql file, by doing the following:
   1. Replace every varchar instance with nvarchar.
   2. Place an N before any insert statement with international strings.

      Japanese example:

      insert into SmUser ( UserID , Name, Password,
      LastName, FirstName, ...)

      values (12, N'',
      'siteminder','guest','guest','guest@mycompany.com...)

2. Import the smsampleusers_sqlserver.sql file.

   Note: More information on importing the smsampleusers_sqlserver.sql file exists in Sample User Directories.

3. Open the Policy Server User Interface's SiteMinder ODBC Query Scheme dialog and modify the policy store's SQL query scheme by placing an N before every %s reference in any = %s statement.

   Example: the following sample query scheme statements:

   select Name, 'User' from SmUser where Name = '%s' Union select Name, 'Group' from SmGroup where Name = '%s'

   should become:

   select Name, 'User' from SmUser where Name = N'%s' Union select Name, 'Group' from SmGroup where Name = N'%s'

4. Stop and restart the Policy Server.

   The user store configuration is complete and now supports multi-byte characters.