Localization Testing

• 

  Can I set in MariaDB the collation based on a IETF language tag?
  mariadb collation localization • • Analeea  

  2
  0
  Votes
  2
  Posts
  17
  Views

  

  (There is no direct way to do what you hypothecate.) Build a Stored procedure that takes "de" as an argument and constructs and executes SELECT word FROM `words` order by word collate utf8mb4_german2_ci It would probably involve a relatively static lookup table that maps "de" and "de-DE" to "utf8mb4_german2_ci", etc. See the docs on defining Stored Procedures and how to use CONCAT(), PREPARE and EXECUTE in such. Run SHOW COLLATION LIKE 'utf8mb4%'; to see which collations are available. (It varies with the MySQL/MariaDB version.)
• R

  Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?
  sql server collation unicode localization case sensitive • • rielyn  

  2
  0
  Votes
  2
  Posts
  4
  Views

  

  Given that this behavior is present in the newer version of that collation, and that combinations such as "fr" and "fR" do match (as expected), it could only be culture-specific linguistic rules for that combination of characters. SELECT CASE WHEN 'tr' = 'tR' COLLATE Vietnamese_100_CI_AI THEN 'Y' ELSE 'N' END; -- N SELECT CASE WHEN 'fr' = 'fR' COLLATE Vietnamese_100_CI_AI THEN 'Y' ELSE 'N' END; -- Y <p>I found the rule in the sort weight file ^{<strong>**</strong>}. It's the combination of "tr" that's special (in Vietnamese), not "tR". It seems that Vietnamese has certain letter combinations that combine to form a single character, such as the "CH" and "LL" combinations in Spanish. So, the following are valid combinations for the "character" that "T" + "R" combine to form in Vietnamese:</p> <ol> <li>tr</li> <li>Tr</li> <li>TR</li> </ol> <p>The combination of "tR" does not form the "TR" character, most likely because that is an unnatural capitalization that more so implies separation of words, such as with Pascal / Camel -casing (e.g. "Cha<strong>tR</strong>oom" and "cha<strong>tR</strong>oom", respectively, as opposed to "<a href="https://homestarrunner.com/sbemails/58-dragon" rel="noreferrer"><strong>tR</strong>ogdor the Burninator</a>") ^{(educated guess on my part)}.</p> <p>The following example shows that the "tr" combination sorts <em>after</em> "tz":</p> <pre class="lang-sql prettyprint-override"><code>SELECT * FROM (VALUES (N'Atra'), (N'Atz'), (N'Aua'), (N'Ata'), (N'AtR')) tmp(col) ORDER BY tmp.[col] COLLATE Vietnamese_100_CI_AI ASC /* Ata AtR Atz Atra Aua */ Those results are due to "tr" combining to form a single character that naturally sorts after "t". Meaning, the sorting algorithm sees the following: Character # 1 | 2 | 3 ------------- A | t | a A | t | R A | t | z A | tr | a A | u | a ``` Vietnamese has other two-letter combinations that work the same way as "TR" (i.e. case-insensitive: tr == Tr == TR <> tR CH GI KH NG NH PH QU TH For more info on working with collations / encodings / Unicode, please visit my site: Collations Info ** A sort weight file contains code points and their respective weight values which are separated into categories such as diacritic weight, case weight, etc. There are usually sections that describe transformations, such a combining two code points to be a single weight for a particular culture/locale (e.g. Vietnamese). There can be mappings for decomposing pre-composed characters into individual characters, etc. Please see: Accessing the Windows Sorting Weight Table. NOTE: Microsoft provides several sort weight files since they have been updated over the years as new versions of Windows and Windows Server have been released. Please keep in mind that none of those files is a 100% match for the rules that SQL Server uses. The closest we get is the Windows Server 2008 Sorting Weight Table.txt file, which should closely match the behavior of the version 100 collations (i.e. those with _100_ in their names).
• 

  First Name & Last Name VS Given Name & Family Name
  forms localization names social • • morde  

  2
  0
  Votes
  2
  Posts
  4
  Views

  Z

  A small tip for those wondering Given name is the same as First name. Answer in two lines You can either go with "How do you prefer to be addressed?" or "Herr Schmitt! We've decided to call you Mistah Caputchi! Simply because we can..." it's important to understand the following to decide on it: Your position from culture Do you want to have a product that is tailored to fit all the different cultures? or do you want to have a vision for a culture that is influencing and driving its users? In the cases of Facebook and Google - and more obvious at Google's side - you can see crystal clear they are trying in a way to enforce a certain culture on their users, you can see the words Social, Fun, Cool even when they sent out the new Pixel 2 with that "Kinda Blue" color. How do both approaches compare? The more you influence culture - by having a vision for it, or a direction or at extreme cases design for it - the more you become niche oriented and becomes less suitable for everyone out there. The more generic your position is the more compatible you are with different cultures, yet your identity becomes weaker and the chances of connection are lower and cultural conflicts are more likely to occur. Metaphor Influencing Culture High Coherence: Think about a group of people that you find yourself belonging to, be it friends, family, colleagues, everyone speaks freely the language used is more connecting as well as the overall feeling. Generic Culture Low Coherence: In a random elevator filled with people you feel the awkwardness that everyone else has, no one is interacting, everyone avoiding eye contact and if anyone would say a word it will probably pre-thought and rehearsed in the mind a thousand times before. Conclusion If you are trying to consciously avoid interfering with cultures more of "Open for all" and you can simply ask the users "How do you prefer to be addressed" If you are willing to have the authority of influence, find the right way of doing it. "All people are called by First Name and Last Name" "All people are called Mr. Capuchi! We don't care..." "All people are called Herr Prof Dr Last Name" you study it and decide it
• T

  How to write currency codes for cryptocurrencies?
  localization placement currency cryptocurrency • • Trenton  

  2
  0
  Votes
  2
  Posts
  3
  Views

  

  In general, symbols are used before the number and short codes are used after the number. So, for Etherium, we could type 10 ETH, I belive.
• C

  Localization guide
  formatting localization • • charlenef  

  2
  0
  Votes
  2
  Posts
  4
  Views

  A

  Have a look at these links about date, time, currency and number formatting: Date format by country Currency designators and country codes (ISO 4217) Number formatting
• T

  Should I override controls so that it handle different locale's or let the browser handle it?
  html html5 localization • • terrea  

  2
  0
  Votes
  2
  Posts
  3
  Views

  A

  On your titular question: Should I override controls so that it handle different locale's or let the browser handle it?, my "go to reason" for not relying on a browser's locale is the situation where someone from the UK arm of a multinational company is visiting the company's offices in France and using a PC there. If the web application is relying on the browser's settings (which more than likely will be set to "French") then the person from the UK has to change those settings, and – if they are being considerate to their hosts – may need to change them back. On the other hand, if the web application has its own way of changing language/locale, then not only will the UK user probably not have to worry about resetting things, they may also never need to change the setting in the first place: If the app never saves the choice (beyond the current session), there's nothing to reset (but anyone wanting to change the locale will have to do so every time). (Assuming users log into the PC with their own username: very likely in a corporate environment If the app saves the choice in a cookie, then the first time someone new uses a given PC, they won't have a cookie and will need to select the locale. Thereafter, when using the same PC they will see their preferred language. Other users (with their own cookies) will not be affected. If the app remembers the user's choice within the app itself, then when "TripeHound" logs in, not only will my choices not affect anyone else, the chances are the app will already know I prefer English and I won't need to change anything. (Only if the app stores the choice in a cookie, and everyone logs into PCs with a generic account would the setting need to be reset. This is an unlikely scenario in a modern business setting. I hope! Nowadays, even in a non-business setting it is common for different people sharing a PC to have their own accounts.) As to the question at the bottom of the question body: should you (continue to?) use custom components to support browsers that don't fully respect the lang= attribute? First I'd note that that seems to be more of a "How do I implement..." question (compared with a "How should I design..." question that SE:UX prefers), nevertheless... Any answer would depend on how important you feel it is for dates/required elements to be fully localized, and how far off you "guestimate" full compliance by popular browsers might be: If it's very important to fully localize, and some mainstream browsers currently don't comply, customized controls is probably the answer. (They won't stop working even if browsers catch up). If full localization is not vital, but more desirable than nice to have, and you've already got customized components (or can lay your hands on suitable implementations of them), then you may as well use them now, at least until browsers catch-up. If full localization is only nice to have, but browsers seem to be moving in the right direction, you might decide that standard controls are "good enough" for the time being, and will be "perfect" when browsers do catch-up.
• J

  Collation for accent-insensitive comparison on Postgres?
  postgresql collation localization • • jonetta  

  2
  0
  Votes
  2
  Posts
  3
  Views

  

  This would be a case sensitice, but accent insensitive locale for Spain that works with recent versions of ICU: CREATE COLLATION spanish_noaccent ( PROVIDER = 'icu', LOCALE = 'es-ES-u-ks-level1-kc', DETERMINISTIC = FALSE ); SELECT 'Olé' = 'Ole' COLLATE spanish_noaccent; ?column? ══════════ t (1 row) SELECT 'Olé' = 'ole' COLLATE spanish_noaccent; ?column? ══════════ f (1 row) ks-level1 means "case and accent insensitive", and kc adds case sensitivity. See my blog post for more.
• 

  What order do stars get filled out in RTL locales?
  gui design localization ratings rtl rating system • • carriann  

  2
  0
  Votes
  2
  Posts
  2
  Views

  

  Star ratings that are displayed in the way you show are essentially discrete horizontal bar charts. It seems like in RTL you should flip the axis, but not doing so would also be accepted. Previously: Is the mental model of time advancing to the right in charts globally accepted? Should graphs and charts be reversed for RTL-reading audiences?
• F

  If a search result is a place that only people who live in a certain area can visit, what's the best way of explaining that?
  search geolocation localization search results • • fbio  

  2
  0
  Votes
  2
  Posts
  3
  Views

  O

  The solution here is to ask for the zip code, or, if the user offers permission, add a "localize me" button as an alternative to asking for the zip code. If the service is unavailable let them know as early as possible, before commencing the flow.
• 

  How do you handle localisation with special tags for long languages
  tags localization • • Alberto  

  2
  0
  Votes
  2
  Posts
  3
  Views

  A

  I think the option you have taken is already the correct one. Your design should always accommodate for larger text (in both font size and length) because you should also be considering accessibility of you design. For example, if this is a web application, then the user might have the browser set to display large fonts or have the zoom set to a higher value than the default 100%. With regards to it "looking odd", it's hard to comment without seeing the rest of your design and where these tags would fit into that. However, I would recommend that you expect tags to sometimes span multiple lines and try to find a design that accommodates that situation just as well as it does for single-line tags.
• 

  Translation of Annual and Monthly pricing as "mo" and "yr"
  accessibility internationalisation localization pricing • • Laycee  

  2
  0
  Votes
  2
  Posts
  3
  Views

  C

  Not really, as a native Spanish speaker I can tell you the words are completely different year=año, month=mes, since they are short there is not really an abbreviation. Other languages haver their own words/abbreviations too. That being said, you will only need to worry about it if you are actually translating the whole site to other languages and you want to keep consistency; to that purpose in some cases you will also need to change the currency sign, not every body uses $. If you are curious you can take a look to the apple site you mention and append a country suffix to see how it's handled Mexico: https://www.apple.com/mx/ Germany https://www.apple.com/de just to list a couple, good luck!
• G

  Decrease the font size or break to a new line with multiple languages?
  gui design internationalisation localization multi language • • gionna  

  2
  0
  Votes
  2
  Posts
  2
  Views

  A

  I recommend a line-break. Imagine how the website would look like with so many different font sizes. Not only would it be "ugly" (although that might be subjective) it would also be difficult to understand the hierarchy of different website elements. What if a headline becomes smaller than the text under it? Is a smaller text less important or was it just too long? Another issue that comes to mind is accessibility: At some point (for very long texts) the font would become so small that it is no longer legible. For people suffering from visual impairments, this will become a problem even sooner. In a worst case scenario your website might become entirely unusable.
• 

  IP address input in RTL language - force LTR?
  mobile internationalisation localization rtl • • Laycee  

  2
  0
  Votes
  2
  Posts
  3
  Views

  

  In general, I would force LTR mode only if the only data in the field will be LTR. If there will be “mixed mode” (both LTR and RTL) data in the field, leave the input as RTL and let the standard input handler decide when to format as LTR.
• N

  Design language and color choices by geography
  gui design interaction design localization color scheme • • nishika  

  2
  0
  Votes
  2
  Posts
  3
  Views

  

  1. Should we have two different design styles based on geography? If it's within your possibilities, YES, absolutely. Many global companies do this, and it's pretty much one of the basics of Universal UX (and by extension, Inclusive UX Design) 2. Is it even relevant that surveyed users seem to prefer a colorful/busy design? Perhaps usability is higher in clean designs, regardless of what people think is more appealing. Completely relevant. Cross-cultural differences should be accepted and embraced. They will only help you provide a better experience for your users. As an example from the link above, look at the photo of China's stock markets where rising stocks are shown in red (which in Western countries would mean falling share prices). There are many ways your project can be successful or a complete failure, just depending on cross-cultural differences.
• 

  How to make sure the website is internationalization compliant?
  manual testing internationalization • • Alberto  

  2
  0
  Votes
  2
  Posts
  3
  Views

  S

  i18n support means making application output relevant to local standards of data representation, so 1st of all you need to establish the requirement on what exactly you'd like to have compliant and for which locales. This might include (but not limited to): Using local language Using local date/time format Using local number representation format Using local currency (symbols, size of fraction part, etc) Providing localized audio/video content Processing content or assuring user-to server communication compliant to local laws and regulations Some UX specific that is relevant to particular locales So i18n does not just mean translate the text. This makes impossible to have dedicated software to test localization. The main challenge is to build test environment that would make your app get into required locale state. This might depend on different things, depending on lot of factors some of which are easy to work around (like cookies or request headers) and some are hard to work around such as end user IP address.
• J

  Is there an option similar to Simtest to test the behavior of mobile devices in different countries?
  mobile internationalization • • juvenalb  

  2
  0
  Votes
  2
  Posts
  3
  Views

  M

  It depends on what exactly you are trying to check. If you are wondering how the app would behave in that specific territory and/or specific mobile service operator, then you have two other options: - Crowdtesting; You can basically hire remote testers from a specific country which will have specific mobile service providers SIM cards. it will be quite cheap if you want to do for example one test case, or short exploratory testing session. For example: http://www.utest.com/ https://www.testcloud.io/ http://www.testbirds.com/ https://crowdsourcedtesting.com/ https://www.pay4bugs.com/ http://www.mob4hire.com/ https://mycrowd.com/ https://test.io/ https://usabilityhub.com/ https://globalapptesting.com/ https://www.bugfinders.com/ http://www.usertesting.com/ http://whatusersdo.com/ http://trymyui.com/ - Mobile Device Labs; So, there are many MDL services that allow you to use mobile devices which are in Poland, Germany, USA, Japan, China or so. Apart from a specific location from Play Store and Internet providers perspective, some of them allows you to use local SIM cards that are already configured in devices. For example: TestDroid TestObject (Sauce labs) Perfecto Mobile NativeTap Kobiton Amazon AWS Device farm Google FireBase Xamarin Test Cloud Experitest Samsung Developers Lab pCloudy BrowserStack
• K

  Any advice on how to test if an application supports different languages
  internationalization • • Kadir  

  2
  0
  Votes
  2
  Posts
  3
  Views

  K

  You could make a file that has all characters possible for a given language. Also you may need to check languages that can be read top to bottom or right to left are handled as expected. Mandarin is a spoken language so you are probably verifying either simplified or traditional Chinese.
• 

  Are special characters in names commonplace enough to test for?
  test design internationalization • • Marcee  

  2
  0
  Votes
  2
  Posts
  4
  Views

  E

  In short, yes. A bit longer a story: on the web in the US Actually there is no such thing. Worldwide is the name of the game. names like Amélie, Jôse, 王 Accents and such ARE important. People from France or Spain or Korea would have their own computer support for these special characters as a matter of course. They usually keep them when moving, for example, to the States. Your name is precious. Not all folks will adapt for easy acceptance while integrating in the new environment. car insurance quotes Best verify what the people in Quotes accept. There should be some guidelines. And in Invoices Generic banking requirements may help here. Non-alphabetic character sets like 王 may be out for procedural reasons. and we also pass on the data Also better check out what the receiving parties support. There SHOULD be something written down as it is beyond company borders. Or you can scrutinize what you, in turn, receive from them. Last resort, that. The technical side: Best keep names separate from the OS. So avoid filenames. Check/test database support settings.
• K

  Typical localization of bugs
  defect tracking quality assessment • • Kadyn  

  2
  0
  Votes
  2
  Posts
  3
  Views

  Y

  Some of the things I've run into: Currency formats are locale dependent. You can also have issues with different locale-based keyboards. I've seen issues where a problem only occurs when the language and the keyboard are configured for a specific locale (this was Turkish language and Turkish keyboard). For German, you'll want to watch your line breaks - German tends to concatenate words so you get very long words that can completely mangle the overall layout. If your application uses a database, you want to make sure the database collation doesn't do anything horrible to the non-ASCII characters the language uses. You also need to make sure that you specify the Unicode format you're working with if there are any exports/imports involved. This isn't as likely with French, German, Spanish, or Italian, but check that there's nowhere in the application that renders the strings as images (I ran into this with Japanese). Image renders for ASCII characters are generally smaller than those outside the ASCII character set, which can cause unusual errors.
• K

  How to test sms containing different language words
  mobile manual testing • • kalyn  

  2
  0
  Votes
  2
  Posts
  3
  Views

  K

  Start by learning something about SMS encoding for example from wikipedia Then try to understand how phones decode and encode SMSs I think you'll have a clearer idea of how and what to test.