column collation


Author
Message
Michel Levy
Michel Levy
Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)Advanced StrataFrame User (607 reputation)
Group: StrataFrame Users
Posts: 193, Visits: 9K
Hi,

working on a new project between France and North-Africa, I'll need arabics collations on certain columns in many tables (the rest of database will be in french_ci_as, or french_ci_ai).

I know I can specifiy it in a post-deployement script, but this implies to create index likewise (alter column ... collate my_collation is forbidden if an index uses this column)

Is there another workaround ? (or a plan inside SF team dreams to add/modify column collation Cool )

Thanks in advance

Reply
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Gotcha. That makes sense. This is something that we would have to change to provide a certain collation on a per column basis. Like I said, we will add this to the list as the DDT is getting some pretty nice upgrades and as we move forward I want to continue to accommodate all needs in this area. So it will make it in, just don't know exactly when. I have just added this post to the "to-do" list.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search