So I guess MS is implementing ISO/IEC 9075-2 Standards, opted not to implement the optional padding attribute and meets the minimal functionality described for character string comparisons set out in ISO/IEC 9075:1992 – that being the default behaviour of padding with the space character.ĭamn.

“Describes the level of support that is provided by Transact-SQL in both SQL Server 2008 R2 and SQL Server 2012 for Part 2: Foundation (SQL/Foundation) of the SQL language ISO/IEC 9075 international standard specification” “: SQL Server Transact-SQL ISO/IEC 9075-2 Standards Support Document A quick check of available collations on my machine yields some 3,800+ options, but with there seemingly being no documentation around checking the “NO PAD” attribute mentioned by the standard, it might be a fair guess to suggest they simply haven’t implemented that attribute at all, opting instead for the default behaviour across all collations… except that link below which clearly describes the NO PAD clause and notes T-SQL does not implement the whole CREATE/DROP functionality. So I guess in the end the MS doc is right to say SQL Server conforms with the standard, except to say that at least with this one collation, they have chosen not to implement the “NO PAD” variation of the standard. I guess SQL Server 2016 follows suit likewise entering “create collation” into a SQL session comes up with syntax error highlighting. Transact-SQL supports a COLLATE clause, but does not support the CREATE COLLATION and DROP COLLATION statements.” “Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows: Transact-SQL partially supports this feature. The end of the MS article states, however: I can see documentation for another RDBMS (MariaDB) recommending creating new sets of collations suffixed with “_NOPAD” to lead the DB to behave more like what we would expect, and yet another RDBMS (MySQL) supports identifying the space padding attribute of collations. The syntax seems to allow for creating new collations based on existing ones. I would guess that 1) “PAD SPACE” is default and 2) my above collation never bothered including that clause. Regardless, the syntax does allow for keywords “NO PAD” and “PAD SPACE” although this clause is optional. I found MS documentation around a CREATE COLLATION statement – but I am really unsure of the context here: this does not appear to be documentation relating to T-SQL (see link 1). Search me but I can’t find a way to obtain the “NO PAD” attribute for the collation affecting me, which is Latin1_General_CI_AS. Implementation-dependent character different from any char-Īcter in the character set of X and Y that collates less IfĬS has the NO PAD attribute, then the pad character is an String by concatenation on the right of one or more pad char-Īcters, where the pad character is chosen based on CS. Itself that has been extended to the length of the longer Replaced, for the purposes of comparison, with a copy of In characters of Y, then the shorter string is effectively

“If the length in characters of X is not equal to the length Phrases are transmitted over the internet with SSL encryption to the 'DeepL' translation service.When you read a littler further into the ANSI standard, you get: The translation algorithm seem to require textual context and seems to be better in translating sentences than in translating individual terms or words.

If you have any questions about the different DeepL products, please contact the provider DeepL. Make sure that you have booked a DeepL Developer account and not the single user account. If the API key is not accepted, check if you mistyped or copied extra characters or spaces. PhraseExpress stores the key with encryption and you cannot restore it from PhraseExpress. Copy & paste the API key into PhraseExpress and press the button next to the input box:.You will receive a personal 'DeepL API key' (example: 43943f3fd-r46f-0kqeb-55c-6lk3l2s183ab8).You would need the 'DeepL Developer - API Free or Pro account': Language translation To use the translation service:

Phraseexpress trailing space