Context : Aims : We present an 8-band ( u ^ { * } , g ^ { { } ^ { \prime } } , r ^ { { } ^ { \prime } } , i ^ { { } ^ { \prime } } , z ^ { { } ^ { \prime } } , Y , J , K _ { s } ) optical to near-infrared deep photometric catalogue based on the observations made with MegaCam and WIRCam at CFHT , and compute photometric redshifts , z _ { p } in the North Ecliptic Pole ( NEP ) region . AKARI infrared satellite carried out deep survey in the NEP region at near to mid infrared wavelength . Our optical to near-infrared catalogue provides us to identify the counterparts , and z _ { p } for the AKARI sources . Methods : We obtained seven ( g ^ { { } ^ { \prime } } , r ^ { { } ^ { \prime } } , i ^ { { } ^ { \prime } } , z ^ { { } ^ { \prime } } , Y , J , K _ { s } ) band imaging data , and we cross-matched them with existing u ^ { * } -band data ( limiting magnitude = 24.6 mag [ 5 \sigma ; AB ] ) to design the band-merged catalogue . We included all z ^ { { } ^ { \prime } } -band sources with counterparts in at least one of the other bands in the catalogue . We used a template-fitting methods to compute z _ { p } for all the catalogued sources . Results : The estimated 4 \sigma detection limits within an 1 arcsec aperture radius are 26.7 , 25.9 , 25.1 , and 24.1 mag [ AB ] for the optical g ^ { { } ^ { \prime } } , r ^ { { } ^ { \prime } } , i ^ { { } ^ { \prime } } , and z ^ { { } ^ { \prime } } -bands and 23.4 , 23.0 , and 22.7 mag for the near-infrared Y , J , and K _ { s } -bands , respectively . There are a total of 85 \hskip { 1.0 pt } 797 sources in the band-merged catalogue . An astrometric accuracy of this catalogue determined by examining coordinate offsets with regard to 2MASS is 0.013 arcsec with a root mean square ( RMS ) offset of 0.32 arcsec . We distinguish 5441 secure stars from extended sources using the u ^ { * } - J versus g ^ { { } ^ { \prime } } - K _ { s } colours , combined with the SExtractor stellarity index of the images . Comparing with galaxy spectroscopic redshifts , we find a photometric redshift dispersion , \sigma _ { \Delta z / ( 1 + z ) } , of 0.032 and catastrophic failure rate , \frac { \Delta z } { 1 + z } > 0.15 , of 5.8 % at z < 1 , while a dispersion of 0.117 and a catastrophic failures rate of 16.6 % at z > 1 . We extend estimate of the z _ { p } uncertainty over the full magnitude/redshift space with a redshift probability distribution function and find that our redshift are highly accurate with z ^ { { } ^ { \prime } } < 22 at z _ { p } < 2.5 and for fainter sources with z ^ { { } ^ { \prime } } < 24 at z < 1 . From the investigation of photometric properties of AKARI infrared sources ( 23 \hskip { 1.0 pt } 354 sources ) using the g ^ { { } ^ { \prime } } z ^ { { } ^ { \prime } } K _ { s } diagram , < 5 % of AKARI sources with optical counterparts are classified as high- z ( 1.4 < z < 2.5 ) star-forming galaxies . Among the high- z star-forming galaxies , AKARI mid-infrared detected sources seem to be affected by stronger dust extinction compared with sources with non-detections in the AKARI MIR bands . The full , electronic version of our 8-band merged catalogue with z _ { p } will be available at the CDS . Conclusions :