Language
database parameter
Description
For those interfaces that support it, specifies the language you
want to use when connecting to your target database.
When to specify Language
You must specify the Language parameter before connecting to the
database. The Language setting takes effect when you connect to the
database.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
Syntax
|
1 |
Language='language_name' |
Default value
None
Usage
When you specify a value for Language, PowerBuilder:
-
Allocates a CS_LOCALE structure for this connection
-
Sets the CS_SYB_LANG value to the language you specify
-
Sets the SQL Server CS_LOC_PROP connection property with the
new locale information
If you have previously set a value for the Locale parameter, which
includes settings for the language and character set you want the Open
Client software to use, you can override the language value by
specifying a new value for the Language parameter and reconnecting to
the database.
Unicode data access
PowerBuilder can access Unicode data in an Adaptive Server
Enterprise (ASE) 12.5 or higher Unicode database or in Unicode columns
in ASE 12.5 or higher. PowerBuilder converts between double-byte
character set (DBCS) data and Unicode automatically, provided that the
Language and CharSet parameters are set with DBCS values (or the Locale
parameter is set with DBCS values).
For example:
|
1 2 |
Language='tchinese' CharSet='big5' |
Examples
To set the Language parameter to French:
-
Database profile
Type French in the Language box on the Connection page or
Regional Settings page in the Database Profile Setup dialog
box. -
Application
Type the following in code:
1SQLCA.DBParm="Language='French'"
See also