oliver

JDBC

Discussion created by oliver on Jul 30, 2012
Latest reply on Jul 30, 2012 by oliver

Hi all,

 

Just wondering if anyone who have experience on using the GetAs function on retrieving the content from a container field.

 

I am working on some experiment without success.

 

Basically, I am trying to draw the data from a container field named "photo" that stored a jpeg file.

 

Example:

 

SELECT GetAs(photo, 'JPEG') as pic FROM company where company_id = 1;

 

 

When viewing the content from the field alias "pic", it shows up some strange characters like this "

 

��� JFIF ��� ' $! "/ #'*,,, 150*5&,,) -% $,,/*,))))),))))),,,),)),),,,,)),2,),,),),*),)),,,,�� `P " �� ��9 ! 1 AQ "aq�b��#2BR�� ��� &3s��� ��! !"1 A Qa�� ?�R4�S' hrXu���I�I �� Ɋc��� �)3 s��s� p�n;B)�.X��*,߫�G}��� �Go �/�Rp1���x��ɗe rT � 2 5 vr���m�6�͗4�N��� � pH�>C&�~ʼn�C1h��� g�I� ��M8M ��#�� �~�"��ʦRX � �l D�O���G��A�(�r��H� �1�� �� �i |-yZ� K�� ���X�y]y� B� &#127; 8 &#127; ��y ЕOh�< ) F 9 g��U�_u�2�� t�m� �Ʀ�i�� � 8�� ��1c�0Ĥj �3�g�Lm�O+> �!a�� �8 �� �'P�ڍ�V� ! ~y��I*Q�����R� � u:�6��# ��eY)t�w� ��f�>� ��B�Ȇ��-� *ǫ&#127;f ɩ R�Lԥ�<��<�+g �e ��Qys �� �5 L[�tͥc�w ��u�w g �R�I a���ܔ~��;���Z��R @%���vnl1 ���(4��>�[����D� Y�F �~�X7� �T4� ���' $ �{7�d � x_� � PβV �G�$ :�X�Ӧ ���^� � b�}#�� �ҹ�u3^� x��� �ţUX� �lRgg�%�y���d�� m� � ����T�&#127;�G�G� N-v�+�� ��?=C�b��� }� I��c 'h� �� �>�� ����R��^g�1�J �H�J[*E �Se� $ �>�� X w�Ϡ��_x> � UǕ)��2H��0��g �5C� ���� &#127;� )�H�B�-�S��;�^~P ��s��%9�1'��� I.�x�, #Jq �����U�x� �Q� Zj�n��-��MI>� 4t�4�T��} Xc{z ���,KI3B[:��N~��� _u� ä�>QE {S�,� ��a�HS �Ѣ-4ɡ�˖����� E W�y�Ud)�3�2<@|C#���̭���֒�IRBO�� �j f��,�J��}�J~ $ �s� �GJ ��������U'5 e!;�J s�� ��"+j^ �ꕢ�|� xJ��|�Z��ܢ�3�Nb$ʹRf��)E� $��E?L(MǴ �K ���J� x �|!��n�� @` � =��#��z�&#154;Q[ Kt�x�Q��+���p%<�� G�Y�Z� /� h}��M (HK �$��s H�"�#I ��� ʍZ��Rn�� � MW �����P# R @I�H��t� @� Y��ϼ x,k�VY7��^Q �� ��H����'��>� }��� ��Y�(�� � u����O���!��F ���ȅZ� QI� p��V��� p=" #Ԅ� �K�]�p A��pS� � 'ڻ�s|)#� � ���� �.t�� ��Ҡ����ǵD�2� yz�eOS$ d�Y f�>�䪑 �U���� �By� ��k ��_ �C M� �K%�o� �9 )2�@a� � [�0�'��[3�zO� � ���]�a$�)RYZw ��#���eܤ }I&#134;�RO=I���U�i�e�"�]A�NҜ�����X�� R� ����� � �� �4�<�)��� �P7�Њ 2�$kS�� �%G'np�N� �|$�/�r��S�� 幜�O$�Ҕ�=O�>SN ���1L�f�d�I>!��1�~`E�a� ��T�7� : � P^'Si�*�W5_A+��.g�K I%���H� &1[�?4t�� a F� �g�R�A ��&C��� D���W����Q8��u�'���� �m�T��m�'��� :T�� _ Mm� �F&#127;X�*t�L ��|���Ƒ� 0 m �t�(�>� ڃM� ��� pQg���J���

 

 

 

 

Any clue? or success case on using the GetAs function.

 

 

Thanks,

Oliver

Outcomes