android - How to query all Korean words start with an initial character -


it easy query words start initial character in english, example query words start "a", execute query:

select * table word 'a%';

we can results "an", "at", "after"....

but not same in korean, because korean word considered single unicode character, query:

select * table word 'ㄱ%';

will not return words "가", "고", "간"... (the results may "ㄱ자", "ㄱ견"...)

so should result expect? (i.e. words "가", "고", "간"... when want query word start "ㄱ")

thank much!

your problem here 1 of unicode format , korean's unique behavior of combining consonants , vowels create new character. can either store these new characters individual glyphs, or combined glyphs. if want search this, need store them individual glyphs. means taking every incoming string stored in db , processing them before inserting them, breaking compound glyphs components. , if have existing db, you'd have existing data well.

the other route make list of every possible combination of glyphs character complex expression in unicode, , search of them massive set of ors.

either way pain in neck. asian languages can real problem programmers, seem have little things make them difficult process.


Comments

Post a Comment

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

Image
recently have uploaded wordpress site onto server. have uploaded wordpress site in sub-folder under root folder ../root(domain root folder)/wordpress (where host wordpress folder). now problem content data in page or post in dashboard of wordpress admin panel not showing - see image. but data showing in front view - see image. if not browser cache issue , not issue happened tinymce editor during upgrade; try add config file: define('concatenate_scripts', false);
Read more

How to get the ip address of VM and use it to configure SSH connection dynamically in Ansible -

i trying ip address of vm , trying use establish ssh vm. following script: --- - hosts: localhost become: yes connection: local gather_facts: false serial: 1 vars_files: - createvmvars.yml tasks: - name: gathering vm info. vsphere_guest: vcenter_hostname: "{{vcenter_hostname}}" username: "{{vcenter_username}}" password: "{{vcenter_password}}" guest: "{{guest_name}}" vmware_guest_facts: yes register: var - debug: msg="{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" - name: establishing ssh connection. script: /home/shasha/devops/scripts/ssh_configure.sh "{{var.ansible_facts.hw_eth0.ipaddresses[0]}}" following content of ssh_configure.sh : #!/bin/sh ssh-keygen -t rsa ssh-copy-id $1 but when running playbook, getting following error while executing third task: error! 'var' undefined but debug module(second task) printin
Read more

javascript - Get parameter of GET request -

i make request: createxhrrequest( "get", fileurl, function( err, response ) { if( err ) { alert( "error get!" ); } alert(response); }); and full response: { "status" : "ok", "message" : "jvberi0xljqkjdduxdgkmy how can jvberi0xlj ? i try response.message , response["message"]. nothing works. just simple access this: var json = json.parse(response); json.message
Read more