Arabic Text inside Static PDF LiveCycle Form is stored in weird order.

please check thread:

 

http://forums.asp.net/p/1828622/5097523.aspx/1?re+sql+server+2000+full+text+search+using+c ontains+to+search+arabic+text+is+not+working

 

after doing lot of testing , investigation, found out following on sql server 2000 under windows server 2003 using indexing service:

 

1. arabic text in static pdf files (created using adobe livecycle desinger static pdf xdp data binding) stored using unicode of connected char shapes in reverse order !!!!!!

 

2. arabic text in ms office files stored using unicode of isolated char shapes in normal order. correct way per expectation.

 

i verified when searching "sick leave" form requests. found, chance, arabic text of "sick" inside "characterization" result field , while looks normal in query analyzer window, when verified unicode value of each letter, figured out going wrong. used following code in query analyzer verify:

 

 

print unicode(substring(n'ﺔﻴﺿﺮﻣ', 5,1))

print unicode(substring(n'مرضية', 1, 1))

print nchar(65251)

print nchar(1605)

 

--- result --->

 

65251

1605

ﻣ

م

 

the following queries returns entirely different results:

 

select * 
  openquery(isrv,  'select filename,path,rank,url,characterization scope() contains(contents, ''"ﺔﻴﺿﺮﻣ"'')') 
order filename 

select * 
  openquery(isrv, 'select filename,path,rank,url,characterization scope() contains(contents, ''"مرضية"'')')
order filename

 

now next question why arabic text inside static pdf file stored in wiered format ????!!!!

i have stored arabic text in regular txt file, until now, not picked indexing service scanning engine (since 1 week). once scanned, confirm result.

 

i think need post question adobe support.

 

any 1 can this?

 

tarek.

More discussions in LiveCycle Designer

adobe