topic Re: JCR and escaping apostrophes in Alfresco Archive

JCR and escaping apostrophes

hiteshlad — Wed, 30 May 2007 21:10:29 GMT

Hi,We're using Alfresco Community 2.0.0 in our custom webapp over JCR/JNDI. This has worked well for us so far. One problem we noticed though on our production server is apostrophe (aka single quotes) are replaced with question marks in some of the fields. I'm just setting them as standard JCR pr

Re: JCR and escaping apostrophes

hiteshlad — Wed, 30 May 2007 23:04:51 GMT

Using this query:

select * from alf_node_properties where string_value like '%father%';‍

and sure enough, the database on the prod environment has the '?' and the database on the test environment has the correct '.

Re: JCR and escaping apostrophes

hiteshlad — Fri, 01 Jun 2007 23:02:06 GMT

Okay, I figured it out. The user actually copied the string "Father's Day" from Microsoft Word. There, the apostrophe isn't a apostrophe. Using the following code:

for (int i = 0; i < sProject.length(); i++) {
    char c = sProject.charAt(i);
    System.out.println(i + ": " + c + "(" + (int)c + ")");
}‍‍‍‍

I figured out the supposed apostrophe character wasn't ASCII code 39 but in fact code 146:

0: F(70)
1: a(97)
2: t(116)
3: h(104)
4: e(101)
5: r(114)
6: ?(146)
7: s(115)
8: D(68)
9: a(97)
10: y(121)‍‍‍‍‍‍‍‍‍‍‍

It is reasonable for the system not to accept this extended ascii character.

In the end, this is just another case of user error. I will be putting a check to make sure all the character codes are < 128.

I hope my internal dialog helps other people.
- hitesh

Re: JCR and escaping apostrophes

nikkijuk — Mon, 25 Jun 2007 08:56:01 GMT

Is your application server JBoss? I am trying to figure out if JCR/JNDI is working with it. So far it seems to me that Tomcat is working fine but JBoss not.

- Jukkis