P
Peter Jakab
With our customer we installed the product, and the sql database is using
Hungarian_CI_AS collation (the default for hungarian installation).
The problem is with this kind of environment is that the customer tried to
create a new enterprise resource, and received an arror of
Duplicate windows account
Altough actually the account to be created was different from any other
already existing in the database.
The new account is
domain\sszanto
The only record that exists in the MSP_WEB_RESOURCES table in
WRES_NT_ACCOUNT column
is
Domain\szszanto
But the two is considered as identical with the Collation the database is
using. ('domain\sszabo'='domain\szszabo' !)
The question is if I can change the Collation for this column is the table
to Hungarian_technical CI_AS (with this collation the two would be
different), or we will face collation conflicts later?
As I see, there is another place where the nt account is stored, the
MSP_TEXT_FIELDS table, where TEXT_FIELD_ID='205521207'
The other question is if I should change the TEXT_VALUE columns collation as
well?
If the column collation changes will couse problems later, what kind of
solution would you advise for this problem?
Hungarian_CI_AS collation (the default for hungarian installation).
The problem is with this kind of environment is that the customer tried to
create a new enterprise resource, and received an arror of
Duplicate windows account
Altough actually the account to be created was different from any other
already existing in the database.
The new account is
domain\sszanto
The only record that exists in the MSP_WEB_RESOURCES table in
WRES_NT_ACCOUNT column
is
Domain\szszanto
But the two is considered as identical with the Collation the database is
using. ('domain\sszabo'='domain\szszabo' !)
The question is if I can change the Collation for this column is the table
to Hungarian_technical CI_AS (with this collation the two would be
different), or we will face collation conflicts later?
As I see, there is another place where the nt account is stored, the
MSP_TEXT_FIELDS table, where TEXT_FIELD_ID='205521207'
The other question is if I should change the TEXT_VALUE columns collation as
well?
If the column collation changes will couse problems later, what kind of
solution would you advise for this problem?