This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Specify collation when creating database
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 20, 2008
08:06 PM
Specify collation when creating database
Is it possible to specify a collation via InstallShield's built-in database creation feature? Reason being is that I have a Windows application that formats dates for the region specified by the OS and submits them to a database. Currently, the SQL database that gets created by my InstallShield setup is configured for SQL_Latin1_General_CP1_CI_AS (English - United States), so whenever a customer has Windows configured for something other than (English - United States) my application will run into troubles.
Ideally, it would be great if the InstallShield setup could detect the region of the OS its running on and create the database with the right collation.
Ideally, it would be great if the InstallShield setup could detect the region of the OS its running on and create the database with the right collation.
(3) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 21, 2008
09:45 AM
You need to turn off the Create Catalog If Absent option, and use your custom SQL script that will create your database. The Create Catalog If Absent option sends a CREATE DATABASE statment with omitting the COLLATE argument. Therefore, the database is assigned the default collation of the instance of SQL Server.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 22, 2010
07:24 PM
This is what I need to do in my installer.
How do I access a variable/property containing the catalog name specified by the user in the sql details dialog? I'm supposing that it is possible to use the text replacement feature to do this replace a placeholder in my script with the database name specified by the user...
(Im new to install shield so forgive me if this is a dumb question)
How do I access a variable/property containing the catalog name specified by the user in the sql details dialog? I'm supposing that it is possible to use the text replacement feature to do this replace a placeholder in my script with the database name specified by the user...
(Im new to install shield so forgive me if this is a dumb question)
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Feb 23, 2010
09:21 AM
In Basic MSI projects, the catalog name field on the SQLLogin dialog is associated with the IS_SQLSERVER_DATABASE Windows Installer property by default. In order to use the catalog name in your SQL script, you need to have a text replacement entry as follows:
Find What: %CatalogName_Placeholder%
Replace With: [IS_SQLSERVER_DATABASE]
and your SQL script would be like this:
CREATE DATABASE %CatalogName_Placeholder%
Hope that helps.
Find What: %CatalogName_Placeholder%
Replace With: [IS_SQLSERVER_DATABASE]
and your SQL script would be like this:
CREATE DATABASE %CatalogName_Placeholder%
Hope that helps.